FaNsldsStudentPortfolioDetail_FAA

EntityType | Independent
Logical Entity Name | FaNsldsStudentPortfolioDetail_FAA
Default Table Name | FaNsldsStudentPortfolioDetail_FAA
Logical Only | NO
Owner | dbo
Definition |
Note |

FaNsldsStudentPortfolioDetail_FAA Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
FaNsldsStudentPortfolioDetailId |  | CHAR(10) | NO |
FaNsldsStudentPortfolioHeaderId |  | CHAR(10) | NO |
SchoolCode |  | CHAR(10) | NO |
SchoolLocationCode |  | CHAR(10) | NO |
BorrowerSSN |  | CHAR(10) | NO |
BorrowerDOB |  | CHAR(10) | NO |
BorrowerLastName |  | CHAR(10) | NO |
BorrowerFirstName |  | CHAR(10) | NO |
BorrowerMiddleName |  | CHAR(10) | YES |
OriginalSchoolCode |  | CHAR(10) | NO |
OriginalSchoolLocationCode |  | CHAR(10) | NO |
AcademicLevel |  | CHAR(10) | YES |
AnticipatedCompletionDate |  | CHAR(10) | YES |
DataProviderOrAwardIdentifier |  | CHAR(10) | NO |
OriginalLenderCode |  | CHAR(10) | YES |
CurrentLenderCode |  | CHAR(10) | YES |
LoanDate |  | CHAR(10) | NO |
LoanType |  | CHAR(10) | NO |
InterestRateCode |  | CHAR(10) | NO |
IndicatorOfSeparateLoan |  | CHAR(10) | NO |
LoanAmount |  | CHAR(10) | YES |
CurrentOPBAmount |  | CHAR(10) | YES |
CurrentOIBAmount |  | CHAR(10) | YES |
CurrentOFBAmount |  | CHAR(10) | YES |
BalanceDate |  | CHAR(10) | NO |
CurrentLoanStatus |  | CHAR(10) | NO |
CurrentLoanStatusDate |  | CHAR(10) | NO |
LoanPeriodBeginDate |  | CHAR(10) | YES |
LoanPeriodEndDate |  | CHAR(10) | YES |
TotalRefundAmount |  | CHAR(10) | YES |
TotalCancellationAmount |  | CHAR(10) | YES |
OriginalGaEdServiceCode |  | CHAR(10) | NO |
CurrentGaEdServiceCode |  | CHAR(10) | NO |
DateEnteredRepayment |  | CHAR(10) | NO |
DelinquencyDate |  | CHAR(10) | YES |
LastPaymentDate |  | CHAR(10) | YES |
ClaimDischargeAmount |  | CHAR(10) | YES |
ClaimDischargeReasonCode |  | CHAR(10) | YES |
ClaimDischargePaidDate |  | CHAR(10) | YES |
CDRDateOfDefault |  | CHAR(10) | YES |
CurrentLoanServicerCode |  | CHAR(10) | YES |
RehabilitationRepurchasedIndicator |  | CHAR(10) | YES |
RehabilitationRepurchasedDate |  | CHAR(10) | YES |
RehabilitationRepurchasedAmount |  | CHAR(10) | YES |
ConsolidationIndicator |  | CHAR(10) | YES |
ConsolidationLoanIdentifier |  | CHAR(10) | YES |
StudentSSN |  | CHAR(10) | NO |
StudentDOB |  | CHAR(10) | YES |
StudentLastName |  | CHAR(10) | YES |
StudentFirstName |  | CHAR(10) | YES |
StudentMiddleName |  | CHAR(10) | YES |
MostRecentRepaymentPlanBeginDate |  | CHAR(10) | YES |
MostRecentRepaymentPlanType |  | CHAR(10) | YES |
MostRecentRepaymentPlanTerm |  | CHAR(10) | YES |
MostRecentScheduledPaymentAmount |  | CHAR(10) | YES |
PaymentDueDay |  | CHAR(10) | YES |
MostRecentDefermentBeginDate |  | CHAR(10) | YES |
MostRecentDefermentEndDate |  | CHAR(10) | YES |
MostRecentDefermentReasonCode |  | CHAR(10) | YES |
MostRecentForbearanceBeginDate |  | CHAR(10) | YES |
MostRecentForbearanceEndDate |  | CHAR(10) | YES |
MostRecentForbearanceReasonCode |  | CHAR(10) | YES |
SULAFlag |  | CHAR(10) | YES |
ConfirmedLoanSubsidyStatus |  | CHAR(10) | YES |
LoanLevelSUP |  | CHAR(10) | YES |
UserId |  | CHAR(10) | NO |
DateAdded |  | CHAR(10) | NO |
DateLstMod |  | CHAR(10) | NO |
ts |  | CHAR(10) | NO |
IsProcessed |  | CHAR(10) | NO |

FaNsldsStudentPortfolioDetail_FAA Keys

Key Name | Key Type | Keys
Pk_FaNsldsStudentPortfolioDetailId | PrimaryKey | FaNsldsStudentPortfolioDetailId

FaNsldsStudentPortfolioDetail_FAA Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
FaNsldsStudentPortfolioHeader_FAA | Non-Identifying | One To Zero or More |  |  |  | FaNsldsStudentPortfolioHeaderId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

FaNsldsStudentPortfolioDetail_FAA Check Constraints

Check Constraint Name | CheckConstraint

FaNsldsStudentPortfolioDetail_FAA Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FaNsldsStudentPortfolioDetail_FAA | NO |  |  |
Physical (Microsoft SQL Server) Does Not Exist | NO |  |  |

FaNsldsStudentPortfolioDetail_FAA Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model

FaNsldsStudentPortfolioDetail_FAA Data Movement Rules

Name | Type | Rule Text/Value